package com.honestpeak.datafusion.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.honestpeak.datafusion.model.ClubMemberInfo;
import com.honestpeak.datafusion.model.Dwh;
import com.honestpeak.datafusion.model.StuProjectMark;
import com.honestpeak.datafusion.model.YearTerm;

public interface ClubMemberInfoMapper {

	List<ClubMemberInfo> getAllClubMember(Long yearTermId);

	Long getYearById(Long yearTermId);

	List<YearTerm> getAllYearTerm();

	List<Dwh> getAllProject();

	List<Dwh> getClubByYearTermId(Long yearTermId);

	List<ClubMemberInfo> getMemberByClubIdAndYTId(@Param("yearTermId")Long yearTermId, @Param("clubId")Long clubId);

	Long maxYearTermId();

	List<ClubMemberInfo> getAllStudent(String[] departNames);

	List<StuProjectMark> getMarkListByYearAndStuNo(@Param("year")Long year, @Param("studentNo")String studentNo);

	List<String> getStuListByDepartIdAndclassId(@Param("departId")Long departId, @Param("classId")Long classId);
}
